﻿CREATE TABLE [dbo].[UserValidateBasis] (
    [UserID]       UNIQUEIDENTIFIER NULL,
    [UseType]      TINYINT          NOT NULL,
    [Token]        UNIQUEIDENTIFIER NULL,
    [AddDate]      DATETIME         NOT NULL,
    [ValidateDate] DATETIME         NULL,
    [VCode]        VARCHAR (8)      NULL,
    [VOriginID]    VARCHAR (256)    NOT NULL,
    [VOriginType]  TINYINT          NOT NULL,
    [IP]           VARCHAR (32)     NULL,
    [ExpireDate]   DATETIME         NULL,
    [TenantID]     UNIQUEIDENTIFIER NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'帐号验证依据表。帐号验证依据管理', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识.前台会员。 UserBaseinfo表', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'UserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证用途.1:忘记密码;2:登录;3:更替原数据', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'UseType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证凭据，机器录入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'Token';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'添加时间.验证生成时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'AddDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'ValidateDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证码.验证凭据，手动录入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'VCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证来源帐号.如：手机号/邮箱', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'VOriginID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证数据类型.1:手机号；2：邮箱', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'VOriginType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'验证过期时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserValidateBasis', @level2type = N'COLUMN', @level2name = N'ExpireDate';

